package com.intelligentcar.springboot.mapper;

import com.intelligentcar.springboot.bean.Driversalary;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface DriversalaryMapper {

    List<Driversalary> LookLook(Driversalary driversalary);

    List<Driversalary> LookTime(@Param(value = "time")String time);


    //展示薪资列表
    List<Driversalary> lookPayroll();

    //查询总条数
    int selectPayroll();
    //修改薪资发放状态
    int updatePayroll(@Param(value = "id")long id);
    //修改薪资明细
    int updateP(@Param(value = "id")long id,
                @Param(value = "drivername")String drivername,
                @Param(value = "salary")String salary,
                @Param(value = "tax")String tax,
                @Param(value = "insurance")String insurance,
                @Param(value = "elsededuct")String elsededuct,
                @Param(value = "practicalSalary")String practicalSalary,
                @Param(value = "time")String time,
                @Param(value = "state")String state
    );
    //删除薪资
    int deleteP(int id);

    //新增薪资
    int addP(Driversalary driversalary);

    //展示薪资列表
    List<Driversalary> Payroll();

}
